package com.beamfield.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class InboundExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public InboundExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andInbound_idIsNull() {
            addCriterion("inbound_id is null");
            return (Criteria) this;
        }

        public Criteria andInbound_idIsNotNull() {
            addCriterion("inbound_id is not null");
            return (Criteria) this;
        }

        public Criteria andInbound_idEqualTo(Long value) {
            addCriterion("inbound_id =", value, "inbound_id");
            return (Criteria) this;
        }

        public Criteria andInbound_idNotEqualTo(Long value) {
            addCriterion("inbound_id <>", value, "inbound_id");
            return (Criteria) this;
        }

        public Criteria andInbound_idGreaterThan(Long value) {
            addCriterion("inbound_id >", value, "inbound_id");
            return (Criteria) this;
        }

        public Criteria andInbound_idGreaterThanOrEqualTo(Long value) {
            addCriterion("inbound_id >=", value, "inbound_id");
            return (Criteria) this;
        }

        public Criteria andInbound_idLessThan(Long value) {
            addCriterion("inbound_id <", value, "inbound_id");
            return (Criteria) this;
        }

        public Criteria andInbound_idLessThanOrEqualTo(Long value) {
            addCriterion("inbound_id <=", value, "inbound_id");
            return (Criteria) this;
        }

        public Criteria andInbound_idIn(List<Long> values) {
            addCriterion("inbound_id in", values, "inbound_id");
            return (Criteria) this;
        }

        public Criteria andInbound_idNotIn(List<Long> values) {
            addCriterion("inbound_id not in", values, "inbound_id");
            return (Criteria) this;
        }

        public Criteria andInbound_idBetween(Long value1, Long value2) {
            addCriterion("inbound_id between", value1, value2, "inbound_id");
            return (Criteria) this;
        }

        public Criteria andInbound_idNotBetween(Long value1, Long value2) {
            addCriterion("inbound_id not between", value1, value2, "inbound_id");
            return (Criteria) this;
        }

        public Criteria andProject_idIsNull() {
            addCriterion("project_id is null");
            return (Criteria) this;
        }

        public Criteria andProject_idIsNotNull() {
            addCriterion("project_id is not null");
            return (Criteria) this;
        }

        public Criteria andProject_idEqualTo(Long value) {
            addCriterion("project_id =", value, "project_id");
            return (Criteria) this;
        }

        public Criteria andProject_idNotEqualTo(Long value) {
            addCriterion("project_id <>", value, "project_id");
            return (Criteria) this;
        }

        public Criteria andProject_idGreaterThan(Long value) {
            addCriterion("project_id >", value, "project_id");
            return (Criteria) this;
        }

        public Criteria andProject_idGreaterThanOrEqualTo(Long value) {
            addCriterion("project_id >=", value, "project_id");
            return (Criteria) this;
        }

        public Criteria andProject_idLessThan(Long value) {
            addCriterion("project_id <", value, "project_id");
            return (Criteria) this;
        }

        public Criteria andProject_idLessThanOrEqualTo(Long value) {
            addCriterion("project_id <=", value, "project_id");
            return (Criteria) this;
        }

        public Criteria andProject_idIn(List<Long> values) {
            addCriterion("project_id in", values, "project_id");
            return (Criteria) this;
        }

        public Criteria andProject_idNotIn(List<Long> values) {
            addCriterion("project_id not in", values, "project_id");
            return (Criteria) this;
        }

        public Criteria andProject_idBetween(Long value1, Long value2) {
            addCriterion("project_id between", value1, value2, "project_id");
            return (Criteria) this;
        }

        public Criteria andProject_idNotBetween(Long value1, Long value2) {
            addCriterion("project_id not between", value1, value2, "project_id");
            return (Criteria) this;
        }

        public Criteria andSupplies_idIsNull() {
            addCriterion("supplies_id is null");
            return (Criteria) this;
        }

        public Criteria andSupplies_idIsNotNull() {
            addCriterion("supplies_id is not null");
            return (Criteria) this;
        }

        public Criteria andSupplies_idEqualTo(String value) {
            addCriterion("supplies_id =", value, "supplies_id");
            return (Criteria) this;
        }

        public Criteria andSupplies_idNotEqualTo(String value) {
            addCriterion("supplies_id <>", value, "supplies_id");
            return (Criteria) this;
        }

        public Criteria andSupplies_idGreaterThan(String value) {
            addCriterion("supplies_id >", value, "supplies_id");
            return (Criteria) this;
        }

        public Criteria andSupplies_idGreaterThanOrEqualTo(String value) {
            addCriterion("supplies_id >=", value, "supplies_id");
            return (Criteria) this;
        }

        public Criteria andSupplies_idLessThan(String value) {
            addCriterion("supplies_id <", value, "supplies_id");
            return (Criteria) this;
        }

        public Criteria andSupplies_idLessThanOrEqualTo(String value) {
            addCriterion("supplies_id <=", value, "supplies_id");
            return (Criteria) this;
        }

        public Criteria andSupplies_idLike(String value) {
            addCriterion("supplies_id like", value, "supplies_id");
            return (Criteria) this;
        }

        public Criteria andSupplies_idNotLike(String value) {
            addCriterion("supplies_id not like", value, "supplies_id");
            return (Criteria) this;
        }

        public Criteria andSupplies_idIn(List<String> values) {
            addCriterion("supplies_id in", values, "supplies_id");
            return (Criteria) this;
        }

        public Criteria andSupplies_idNotIn(List<String> values) {
            addCriterion("supplies_id not in", values, "supplies_id");
            return (Criteria) this;
        }

        public Criteria andSupplies_idBetween(String value1, String value2) {
            addCriterion("supplies_id between", value1, value2, "supplies_id");
            return (Criteria) this;
        }

        public Criteria andSupplies_idNotBetween(String value1, String value2) {
            addCriterion("supplies_id not between", value1, value2, "supplies_id");
            return (Criteria) this;
        }

        public Criteria andManufacturerIsNull() {
            addCriterion("manufacturer is null");
            return (Criteria) this;
        }

        public Criteria andManufacturerIsNotNull() {
            addCriterion("manufacturer is not null");
            return (Criteria) this;
        }

        public Criteria andManufacturerEqualTo(String value) {
            addCriterion("manufacturer =", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotEqualTo(String value) {
            addCriterion("manufacturer <>", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerGreaterThan(String value) {
            addCriterion("manufacturer >", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerGreaterThanOrEqualTo(String value) {
            addCriterion("manufacturer >=", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerLessThan(String value) {
            addCriterion("manufacturer <", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerLessThanOrEqualTo(String value) {
            addCriterion("manufacturer <=", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerLike(String value) {
            addCriterion("manufacturer like", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotLike(String value) {
            addCriterion("manufacturer not like", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerIn(List<String> values) {
            addCriterion("manufacturer in", values, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotIn(List<String> values) {
            addCriterion("manufacturer not in", values, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerBetween(String value1, String value2) {
            addCriterion("manufacturer between", value1, value2, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotBetween(String value1, String value2) {
            addCriterion("manufacturer not between", value1, value2, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andBatch_numberIsNull() {
            addCriterion("batch_number is null");
            return (Criteria) this;
        }

        public Criteria andBatch_numberIsNotNull() {
            addCriterion("batch_number is not null");
            return (Criteria) this;
        }

        public Criteria andBatch_numberEqualTo(String value) {
            addCriterion("batch_number =", value, "batch_number");
            return (Criteria) this;
        }

        public Criteria andBatch_numberNotEqualTo(String value) {
            addCriterion("batch_number <>", value, "batch_number");
            return (Criteria) this;
        }

        public Criteria andBatch_numberGreaterThan(String value) {
            addCriterion("batch_number >", value, "batch_number");
            return (Criteria) this;
        }

        public Criteria andBatch_numberGreaterThanOrEqualTo(String value) {
            addCriterion("batch_number >=", value, "batch_number");
            return (Criteria) this;
        }

        public Criteria andBatch_numberLessThan(String value) {
            addCriterion("batch_number <", value, "batch_number");
            return (Criteria) this;
        }

        public Criteria andBatch_numberLessThanOrEqualTo(String value) {
            addCriterion("batch_number <=", value, "batch_number");
            return (Criteria) this;
        }

        public Criteria andBatch_numberLike(String value) {
            addCriterion("batch_number like", value, "batch_number");
            return (Criteria) this;
        }

        public Criteria andBatch_numberNotLike(String value) {
            addCriterion("batch_number not like", value, "batch_number");
            return (Criteria) this;
        }

        public Criteria andBatch_numberIn(List<String> values) {
            addCriterion("batch_number in", values, "batch_number");
            return (Criteria) this;
        }

        public Criteria andBatch_numberNotIn(List<String> values) {
            addCriterion("batch_number not in", values, "batch_number");
            return (Criteria) this;
        }

        public Criteria andBatch_numberBetween(String value1, String value2) {
            addCriterion("batch_number between", value1, value2, "batch_number");
            return (Criteria) this;
        }

        public Criteria andBatch_numberNotBetween(String value1, String value2) {
            addCriterion("batch_number not between", value1, value2, "batch_number");
            return (Criteria) this;
        }

        public Criteria andLogisitcs_numberIsNull() {
            addCriterion("logisitcs_number is null");
            return (Criteria) this;
        }

        public Criteria andLogisitcs_numberIsNotNull() {
            addCriterion("logisitcs_number is not null");
            return (Criteria) this;
        }

        public Criteria andLogisitcs_numberEqualTo(String value) {
            addCriterion("logisitcs_number =", value, "logisitcs_number");
            return (Criteria) this;
        }

        public Criteria andLogisitcs_numberNotEqualTo(String value) {
            addCriterion("logisitcs_number <>", value, "logisitcs_number");
            return (Criteria) this;
        }

        public Criteria andLogisitcs_numberGreaterThan(String value) {
            addCriterion("logisitcs_number >", value, "logisitcs_number");
            return (Criteria) this;
        }

        public Criteria andLogisitcs_numberGreaterThanOrEqualTo(String value) {
            addCriterion("logisitcs_number >=", value, "logisitcs_number");
            return (Criteria) this;
        }

        public Criteria andLogisitcs_numberLessThan(String value) {
            addCriterion("logisitcs_number <", value, "logisitcs_number");
            return (Criteria) this;
        }

        public Criteria andLogisitcs_numberLessThanOrEqualTo(String value) {
            addCriterion("logisitcs_number <=", value, "logisitcs_number");
            return (Criteria) this;
        }

        public Criteria andLogisitcs_numberLike(String value) {
            addCriterion("logisitcs_number like", value, "logisitcs_number");
            return (Criteria) this;
        }

        public Criteria andLogisitcs_numberNotLike(String value) {
            addCriterion("logisitcs_number not like", value, "logisitcs_number");
            return (Criteria) this;
        }

        public Criteria andLogisitcs_numberIn(List<String> values) {
            addCriterion("logisitcs_number in", values, "logisitcs_number");
            return (Criteria) this;
        }

        public Criteria andLogisitcs_numberNotIn(List<String> values) {
            addCriterion("logisitcs_number not in", values, "logisitcs_number");
            return (Criteria) this;
        }

        public Criteria andLogisitcs_numberBetween(String value1, String value2) {
            addCriterion("logisitcs_number between", value1, value2, "logisitcs_number");
            return (Criteria) this;
        }

        public Criteria andLogisitcs_numberNotBetween(String value1, String value2) {
            addCriterion("logisitcs_number not between", value1, value2, "logisitcs_number");
            return (Criteria) this;
        }

        public Criteria andItimeIsNull() {
            addCriterion("itime is null");
            return (Criteria) this;
        }

        public Criteria andItimeIsNotNull() {
            addCriterion("itime is not null");
            return (Criteria) this;
        }

        public Criteria andItimeEqualTo(Date value) {
            addCriterionForJDBCDate("itime =", value, "itime");
            return (Criteria) this;
        }

        public Criteria andItimeNotEqualTo(Date value) {
            addCriterionForJDBCDate("itime <>", value, "itime");
            return (Criteria) this;
        }

        public Criteria andItimeGreaterThan(Date value) {
            addCriterionForJDBCDate("itime >", value, "itime");
            return (Criteria) this;
        }

        public Criteria andItimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("itime >=", value, "itime");
            return (Criteria) this;
        }

        public Criteria andItimeLessThan(Date value) {
            addCriterionForJDBCDate("itime <", value, "itime");
            return (Criteria) this;
        }

        public Criteria andItimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("itime <=", value, "itime");
            return (Criteria) this;
        }

        public Criteria andItimeIn(List<Date> values) {
            addCriterionForJDBCDate("itime in", values, "itime");
            return (Criteria) this;
        }

        public Criteria andItimeNotIn(List<Date> values) {
            addCriterionForJDBCDate("itime not in", values, "itime");
            return (Criteria) this;
        }

        public Criteria andItimeBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("itime between", value1, value2, "itime");
            return (Criteria) this;
        }

        public Criteria andItimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("itime not between", value1, value2, "itime");
            return (Criteria) this;
        }

        public Criteria andQuality_fileIsNull() {
            addCriterion("quality_file is null");
            return (Criteria) this;
        }

        public Criteria andQuality_fileIsNotNull() {
            addCriterion("quality_file is not null");
            return (Criteria) this;
        }

        public Criteria andQuality_fileEqualTo(Long value) {
            addCriterion("quality_file =", value, "quality_file");
            return (Criteria) this;
        }

        public Criteria andQuality_fileNotEqualTo(Long value) {
            addCriterion("quality_file <>", value, "quality_file");
            return (Criteria) this;
        }

        public Criteria andQuality_fileGreaterThan(Long value) {
            addCriterion("quality_file >", value, "quality_file");
            return (Criteria) this;
        }

        public Criteria andQuality_fileGreaterThanOrEqualTo(Long value) {
            addCriterion("quality_file >=", value, "quality_file");
            return (Criteria) this;
        }

        public Criteria andQuality_fileLessThan(Long value) {
            addCriterion("quality_file <", value, "quality_file");
            return (Criteria) this;
        }

        public Criteria andQuality_fileLessThanOrEqualTo(Long value) {
            addCriterion("quality_file <=", value, "quality_file");
            return (Criteria) this;
        }

        public Criteria andQuality_fileIn(List<Long> values) {
            addCriterion("quality_file in", values, "quality_file");
            return (Criteria) this;
        }

        public Criteria andQuality_fileNotIn(List<Long> values) {
            addCriterion("quality_file not in", values, "quality_file");
            return (Criteria) this;
        }

        public Criteria andQuality_fileBetween(Long value1, Long value2) {
            addCriterion("quality_file between", value1, value2, "quality_file");
            return (Criteria) this;
        }

        public Criteria andQuality_fileNotBetween(Long value1, Long value2) {
            addCriterion("quality_file not between", value1, value2, "quality_file");
            return (Criteria) this;
        }

        public Criteria andNumberIsNull() {
            addCriterion("number is null");
            return (Criteria) this;
        }

        public Criteria andNumberIsNotNull() {
            addCriterion("number is not null");
            return (Criteria) this;
        }

        public Criteria andNumberEqualTo(Double value) {
            addCriterion("number =", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberNotEqualTo(Double value) {
            addCriterion("number <>", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberGreaterThan(Double value) {
            addCriterion("number >", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberGreaterThanOrEqualTo(Double value) {
            addCriterion("number >=", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberLessThan(Double value) {
            addCriterion("number <", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberLessThanOrEqualTo(Double value) {
            addCriterion("number <=", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberIn(List<Double> values) {
            addCriterion("number in", values, "number");
            return (Criteria) this;
        }

        public Criteria andNumberNotIn(List<Double> values) {
            addCriterion("number not in", values, "number");
            return (Criteria) this;
        }

        public Criteria andNumberBetween(Double value1, Double value2) {
            addCriterion("number between", value1, value2, "number");
            return (Criteria) this;
        }

        public Criteria andNumberNotBetween(Double value1, Double value2) {
            addCriterion("number not between", value1, value2, "number");
            return (Criteria) this;
        }

        public Criteria andStorage_placeIsNull() {
            addCriterion("storage_place is null");
            return (Criteria) this;
        }

        public Criteria andStorage_placeIsNotNull() {
            addCriterion("storage_place is not null");
            return (Criteria) this;
        }

        public Criteria andStorage_placeEqualTo(String value) {
            addCriterion("storage_place =", value, "storage_place");
            return (Criteria) this;
        }

        public Criteria andStorage_placeNotEqualTo(String value) {
            addCriterion("storage_place <>", value, "storage_place");
            return (Criteria) this;
        }

        public Criteria andStorage_placeGreaterThan(String value) {
            addCriterion("storage_place >", value, "storage_place");
            return (Criteria) this;
        }

        public Criteria andStorage_placeGreaterThanOrEqualTo(String value) {
            addCriterion("storage_place >=", value, "storage_place");
            return (Criteria) this;
        }

        public Criteria andStorage_placeLessThan(String value) {
            addCriterion("storage_place <", value, "storage_place");
            return (Criteria) this;
        }

        public Criteria andStorage_placeLessThanOrEqualTo(String value) {
            addCriterion("storage_place <=", value, "storage_place");
            return (Criteria) this;
        }

        public Criteria andStorage_placeLike(String value) {
            addCriterion("storage_place like", value, "storage_place");
            return (Criteria) this;
        }

        public Criteria andStorage_placeNotLike(String value) {
            addCriterion("storage_place not like", value, "storage_place");
            return (Criteria) this;
        }

        public Criteria andStorage_placeIn(List<String> values) {
            addCriterion("storage_place in", values, "storage_place");
            return (Criteria) this;
        }

        public Criteria andStorage_placeNotIn(List<String> values) {
            addCriterion("storage_place not in", values, "storage_place");
            return (Criteria) this;
        }

        public Criteria andStorage_placeBetween(String value1, String value2) {
            addCriterion("storage_place between", value1, value2, "storage_place");
            return (Criteria) this;
        }

        public Criteria andStorage_placeNotBetween(String value1, String value2) {
            addCriterion("storage_place not between", value1, value2, "storage_place");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("type is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("type is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(Integer value) {
            addCriterion("type =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(Integer value) {
            addCriterion("type <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(Integer value) {
            addCriterion("type >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("type >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(Integer value) {
            addCriterion("type <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(Integer value) {
            addCriterion("type <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<Integer> values) {
            addCriterion("type in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<Integer> values) {
            addCriterion("type not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(Integer value1, Integer value2) {
            addCriterion("type between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("type not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andOperatorIsNull() {
            addCriterion("operator is null");
            return (Criteria) this;
        }

        public Criteria andOperatorIsNotNull() {
            addCriterion("operator is not null");
            return (Criteria) this;
        }

        public Criteria andOperatorEqualTo(Long value) {
            addCriterion("operator =", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorNotEqualTo(Long value) {
            addCriterion("operator <>", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorGreaterThan(Long value) {
            addCriterion("operator >", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorGreaterThanOrEqualTo(Long value) {
            addCriterion("operator >=", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorLessThan(Long value) {
            addCriterion("operator <", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorLessThanOrEqualTo(Long value) {
            addCriterion("operator <=", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorIn(List<Long> values) {
            addCriterion("operator in", values, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorNotIn(List<Long> values) {
            addCriterion("operator not in", values, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorBetween(Long value1, Long value2) {
            addCriterion("operator between", value1, value2, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorNotBetween(Long value1, Long value2) {
            addCriterion("operator not between", value1, value2, "operator");
            return (Criteria) this;
        }

        public Criteria andAddtimeIsNull() {
            addCriterion("addtime is null");
            return (Criteria) this;
        }

        public Criteria andAddtimeIsNotNull() {
            addCriterion("addtime is not null");
            return (Criteria) this;
        }

        public Criteria andAddtimeEqualTo(Date value) {
            addCriterion("addtime =", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeNotEqualTo(Date value) {
            addCriterion("addtime <>", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeGreaterThan(Date value) {
            addCriterion("addtime >", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("addtime >=", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeLessThan(Date value) {
            addCriterion("addtime <", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeLessThanOrEqualTo(Date value) {
            addCriterion("addtime <=", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeIn(List<Date> values) {
            addCriterion("addtime in", values, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeNotIn(List<Date> values) {
            addCriterion("addtime not in", values, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeBetween(Date value1, Date value2) {
            addCriterion("addtime between", value1, value2, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeNotBetween(Date value1, Date value2) {
            addCriterion("addtime not between", value1, value2, "addtime");
            return (Criteria) this;
        }

        public Criteria andUpdaterIsNull() {
            addCriterion("updater is null");
            return (Criteria) this;
        }

        public Criteria andUpdaterIsNotNull() {
            addCriterion("updater is not null");
            return (Criteria) this;
        }

        public Criteria andUpdaterEqualTo(Long value) {
            addCriterion("updater =", value, "updater");
            return (Criteria) this;
        }

        public Criteria andUpdaterNotEqualTo(Long value) {
            addCriterion("updater <>", value, "updater");
            return (Criteria) this;
        }

        public Criteria andUpdaterGreaterThan(Long value) {
            addCriterion("updater >", value, "updater");
            return (Criteria) this;
        }

        public Criteria andUpdaterGreaterThanOrEqualTo(Long value) {
            addCriterion("updater >=", value, "updater");
            return (Criteria) this;
        }

        public Criteria andUpdaterLessThan(Long value) {
            addCriterion("updater <", value, "updater");
            return (Criteria) this;
        }

        public Criteria andUpdaterLessThanOrEqualTo(Long value) {
            addCriterion("updater <=", value, "updater");
            return (Criteria) this;
        }

        public Criteria andUpdaterIn(List<Long> values) {
            addCriterion("updater in", values, "updater");
            return (Criteria) this;
        }

        public Criteria andUpdaterNotIn(List<Long> values) {
            addCriterion("updater not in", values, "updater");
            return (Criteria) this;
        }

        public Criteria andUpdaterBetween(Long value1, Long value2) {
            addCriterion("updater between", value1, value2, "updater");
            return (Criteria) this;
        }

        public Criteria andUpdaterNotBetween(Long value1, Long value2) {
            addCriterion("updater not between", value1, value2, "updater");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNull() {
            addCriterion("updatetime is null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNotNull() {
            addCriterion("updatetime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeEqualTo(Date value) {
            addCriterion("updatetime =", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotEqualTo(Date value) {
            addCriterion("updatetime <>", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThan(Date value) {
            addCriterion("updatetime >", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("updatetime >=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThan(Date value) {
            addCriterion("updatetime <", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThanOrEqualTo(Date value) {
            addCriterion("updatetime <=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIn(List<Date> values) {
            addCriterion("updatetime in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotIn(List<Date> values) {
            addCriterion("updatetime not in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeBetween(Date value1, Date value2) {
            addCriterion("updatetime between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotBetween(Date value1, Date value2) {
            addCriterion("updatetime not between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andBeam_idIsNull() {
            addCriterion("beam_id is null");
            return (Criteria) this;
        }

        public Criteria andBeam_idIsNotNull() {
            addCriterion("beam_id is not null");
            return (Criteria) this;
        }

        public Criteria andBeam_idEqualTo(Integer value) {
            addCriterion("beam_id =", value, "beam_id");
            return (Criteria) this;
        }

        public Criteria andBeam_idNotEqualTo(Integer value) {
            addCriterion("beam_id <>", value, "beam_id");
            return (Criteria) this;
        }

        public Criteria andBeam_idGreaterThan(Integer value) {
            addCriterion("beam_id >", value, "beam_id");
            return (Criteria) this;
        }

        public Criteria andBeam_idGreaterThanOrEqualTo(Integer value) {
            addCriterion("beam_id >=", value, "beam_id");
            return (Criteria) this;
        }

        public Criteria andBeam_idLessThan(Integer value) {
            addCriterion("beam_id <", value, "beam_id");
            return (Criteria) this;
        }

        public Criteria andBeam_idLessThanOrEqualTo(Integer value) {
            addCriterion("beam_id <=", value, "beam_id");
            return (Criteria) this;
        }

        public Criteria andBeam_idIn(List<Integer> values) {
            addCriterion("beam_id in", values, "beam_id");
            return (Criteria) this;
        }

        public Criteria andBeam_idNotIn(List<Integer> values) {
            addCriterion("beam_id not in", values, "beam_id");
            return (Criteria) this;
        }

        public Criteria andBeam_idBetween(Integer value1, Integer value2) {
            addCriterion("beam_id between", value1, value2, "beam_id");
            return (Criteria) this;
        }

        public Criteria andBeam_idNotBetween(Integer value1, Integer value2) {
            addCriterion("beam_id not between", value1, value2, "beam_id");
            return (Criteria) this;
        }

        public Criteria andPurchase_plan_idIsNull() {
            addCriterion("purchase_plan_id is null");
            return (Criteria) this;
        }

        public Criteria andPurchase_plan_idIsNotNull() {
            addCriterion("purchase_plan_id is not null");
            return (Criteria) this;
        }

        public Criteria andPurchase_plan_idEqualTo(Long value) {
            addCriterion("purchase_plan_id =", value, "purchase_plan_id");
            return (Criteria) this;
        }

        public Criteria andPurchase_plan_idNotEqualTo(Long value) {
            addCriterion("purchase_plan_id <>", value, "purchase_plan_id");
            return (Criteria) this;
        }

        public Criteria andPurchase_plan_idGreaterThan(Long value) {
            addCriterion("purchase_plan_id >", value, "purchase_plan_id");
            return (Criteria) this;
        }

        public Criteria andPurchase_plan_idGreaterThanOrEqualTo(Long value) {
            addCriterion("purchase_plan_id >=", value, "purchase_plan_id");
            return (Criteria) this;
        }

        public Criteria andPurchase_plan_idLessThan(Long value) {
            addCriterion("purchase_plan_id <", value, "purchase_plan_id");
            return (Criteria) this;
        }

        public Criteria andPurchase_plan_idLessThanOrEqualTo(Long value) {
            addCriterion("purchase_plan_id <=", value, "purchase_plan_id");
            return (Criteria) this;
        }

        public Criteria andPurchase_plan_idIn(List<Long> values) {
            addCriterion("purchase_plan_id in", values, "purchase_plan_id");
            return (Criteria) this;
        }

        public Criteria andPurchase_plan_idNotIn(List<Long> values) {
            addCriterion("purchase_plan_id not in", values, "purchase_plan_id");
            return (Criteria) this;
        }

        public Criteria andPurchase_plan_idBetween(Long value1, Long value2) {
            addCriterion("purchase_plan_id between", value1, value2, "purchase_plan_id");
            return (Criteria) this;
        }

        public Criteria andPurchase_plan_idNotBetween(Long value1, Long value2) {
            addCriterion("purchase_plan_id not between", value1, value2, "purchase_plan_id");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}